{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sous Vide"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sous Vide","index":0,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,24,69,25],[59,0,59,6],[11,0,11,6],[16,0,16,6],[26,10,26,11],[28,10,28,11],[29,10,29,11],[67,9,67,14],[59,9,59,14],[9,0,9,6],[56,0,56,6],[61,9,61,14],[65,9,65,14],[16,12,16,16],[20,12,20,14],[21,12,21,16],[25,0,25,6],[17,12,17,15],[25,8,25,9],[16,8,16,9],[14,14,14,17],[13,10,13,19],[14,10,14,13],[14,18,14,21],[2,8,2,9],[8,18,8,21],[2,14,2,17],[3,8,10,8],[0,0,0,6],[2,0,2,5],[1,0,1,6],[4,9,5,9],[6,9,7,9],[8,9,9,9],[6,16,7,17],[1,8,1,9],[6,10,6,13],[6,14,7,15],[0,12,0,19],[4,10,4,13]]}
["Adding Hysteresis to the plus input of a Comparator LM339/LM393",null,null,null,null,null,null,null,null,null,null,null,"Temperature as a function of Time"]
["with 3 resistors Rx, Ry, R18 and one potentiometer P1",null,null,null,null,null,null,null,"Temperature °C"]
["Values ​​in K Ohm",null,null,null,null,null,"Volt",null,"Max Delta is selected",null,null,null,null,null,{"$f":"+A26","v":"Temperature with P1 0% = 0 Ω"}]
["Rx=(R6 to R11)","Ry=(R12 to R17)","R18","P1","P1 i %","R20","Vcc",null,"Selected temperature"]
[130,110,1200,2200,0,3.3,12,null,null,{"$f":"CONCATENATE(F11*10,N19)","v":"57,2 °C"},"\"Turns off\" on rising temperature"]
[]
["R1 combined = 1/(1/Rx+1/(R20+R3 combined))",null,null,{"$f":"+I26","v":"S1 Off"},null,{"$f":"1/(1/A5+1/(F5+F9))","v":120.89586812476431},"K Ohm",null,null,{"$f":"CONCATENATE(((F11+F13)/2)*10,N19)","v":"55,2 °C"},"Average temperature",null,null,null,{"$f":"CONCATENATE((F14*10),N19)","v":"4 °C"},null,"Delta temp"]
["R2 combined = 1/(1/Ry+1/R3 combined)",null,"R18","R19","P1",{"$f":"1/(1/B5+1/F9)","v":103.39879978177852},"K Ohm"]
["R3 combined = R18+R19+P1",null,{"$f":"+C5","v":1200},523,{"$f":"D5*E5","v":0},{"$f":"SUM(C9:E9)","v":1723},"K Ohm",null,null,{"$f":"CONCATENATE(F13*10,N19)","v":"53,2 °C"},null,null,null,null,null,null,null,null,"\"Turns on\" on falling temperature"]
["Calculating Reference Voltage Off"]
["V Reference Off = (Vcc/(R1 combined + R2)) * R2",null,null,null,null,{"$f":"+ROUND(((G5/(F7+B5))*B5),2)","v":5.72},"Volt"]
["Calculating Reference Voltage On"]
["V Reference On = (Vcc/(R1 + R2 combined)) * R2 Combined",null,null,null,null,{"$f":"+ROUND(((G5/(A5+F8))*F8),2)","v":5.32},"Volt"]
["Hysteresis Shift Voltages = V Ref Off - V Ref On",null,null,null,null,{"$f":"+ROUND(F11-F13,2)","v":0.4},"Volt",null,null,null,"The heating element status",null,null,null,null,null,null,null,null,null,null,"Time"]
[null,null,null,null,null,null,null,null,null,null,"On",null,null,null,"Off",null,null,null,"On"]
[]
["Temperature with P1 100% = 2.2M Ω",null,null,null,null,null,null,null,"Select Data",null,null,null,"Gain in LM324",null,null,null,null,null,"Insert the values ​​in the yellow cells (remember in K Ohm)"]
["Switch Pos. No.","Voff","Von","Hys. Shift Volt","Max °C","Min °C","Hys. Shift Temp",null,"P1 = 100%","P1 = 0%",null,null,"Resistors in K Ohm",null,null,null,null,null,"Also set PO trimmer - in the red cell - the same value as specified in P20"]
["1.      45 °C",4.6500000000000004,4.46,{"$f":"+B19-C19","v":0.19000000000000039},{"$f":"+B19*10","v":46.5},{"$f":"C19*10","v":44.6},{"$f":"E19-F19","v":1.8999999999999986},null,null,null,null,null,"R4"," °C","R3","PO trim","PO i %",null,"Make a What-if analysis targeting: Enter cell O23 to value 10 by changing P21"]
["2.      50 °C",5.12,4.92,{"$f":"+B20-C20","v":0.20000000000000018},{"$f":"+B20*10","v":51.2},{"$f":"C20*10","v":49.2},{"$f":"E20-F20","v":2},null,null,null,null,null,91,null,10,0.2,{"$f":"+P21/P20","v":0.54999999999999993},null,"The result in % of setting PO trimmer can be seen in green cell Q20"]
["3.      55 °C",5.61,5.41,0.20000000000000018,56.1,54.1,2,null,null,null,null,null,"PO trimmer actual value",null,null,0.11,"K Ohm",null,"The result of Ohm setting of PO trimmer can be seen in red cell P21"]
["4.      60 °C",6.11,5.89,0.22000000000000064,61.1,58.9,2.2000000000000028,null,null,null,null,null,"P0 is a trimmer in serie with R3",null,null,null,null,null,"Please note:"]
["5.      65 °C",6.56,6.34,0.21999999999999975,65.599999999999994,63.4,2.1999999999999957,null,null,null,null,null,"Av = (1+R4/(R3+PO)) =",null,{"$f":"1+M20/(O20+P21)","v":10.000989119683481},{"$f":"20*LOG10(O23)","v":20.000859095954219},"dB",null,"I don't use P0 in this diagram, but I place a 110 Ohm resistor in series with R3"]
["6.      70 °C",7.11,6.88,0.23000000000000043,71.100000000000009,68.8,2.3000000000000114,null,null,null,null,null,null,null,null,null,null,null,"R3 in the diagram consists of two resistors - 10k ohms and 110 ohms in series"]
[]
["Temperature with P1 0% = 0 Ω",null,null,null,null,null,null,null,{"$f":"+K28","v":"S1 Off"}]
["Switch Pos. No.","Voff","Von","Hys. Shift Volt","Max °C","Min °C","Hys. Shift Temp",null,null,null,"Insert R19"]
["1.      45 °C",4.87,4.33,{"$f":"+B28-C28","v":0.54},{"$f":"+B28*10","v":48.7},{"$f":"C28*10","v":43.3},{"$f":"E28-F28","v":5.4000000000000057},null,null,null,"S1 Off"]
["2.      50 °C",5.32,4.7699999999999996,{"$f":"+B29-C29","v":0.55000000000000071},{"$f":"+B29*10","v":53.2},{"$f":"C29*10","v":47.699999999999996},{"$f":"E29-F29","v":5.5000000000000071}]
["3.      55 °C",5.81,5.24,0.5699999999999994,58.099999999999994,52.400000000000006,5.6999999999999886,null,null,null,"Remove R19"]
["4.      60 °C",6.29,5.71,0.58000000000000007,62.9,57.1,5.7999999999999972,null,null,null,"S1 On"]
["5.      65 °C",6.74,6.13,0.61000000000000032,67.400000000000006,61.3,6.1000000000000085]
["6.      70 °C",7.28,6.65,0.62999999999999989,72.8,66.5,6.2999999999999972]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"The spreadsheet is not protected by Password"]
[]
[null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
["walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg.No.1277"]